AL Mandatory Fields

Smart and conditional mandatory fields for Business Central

Overview

AL Mandatory Fields allows you to define flexible and conditional mandatory field rules for the three main master data tables in Microsoft Dynamics 365 Business Central: Customers, Vendors, and Items.

Beyond basic mandatory field settings, the app enables you to create conditional rules based on the values of other fields in the same record.
For each field, you can define multiple sets of conditions, each containing a list of filters (using standard Business Central filter syntax).

When all filters within a condition set are true, the system treats the field as mandatory.
If the field is not filled in:

• A clear message specifies which field is required, and
• The record (Customer, Vendor, or Item) is automatically blocked until the data is completed.

In other words:

• Multiple condition sets = OR logic between groups
• Multiple filters per set = AND logic within the group

Features

• Customizable mandatory fields for Customers, Vendors, and Items
• Define multiple sets of conditional rules per field
• Real-time validation with clear user messages
• Automatic blocking of incomplete records
• No customization of standard Business Central code
• Simple configuration via user interface

Examples

• “VAT Registration No.” is mandatory if Country/Region = IT or Customer Type = Company
• “Item Category Code” required if Type = Inventory and Inventory = Yes
• “Vendor Posting Group” mandatory if Foreign Vendor = Yes or Payment Method = Bank Transfer

Benefits

• Ensure data quality and consistency across master data
• Define complex conditional rules without AL development
• Prevent incomplete or invalid records
• No customization of standard Business Central code
• Easy configuration via intuitive interface

Supported Editions and Versions

Supported Editions:

• Microsoft Dynamics 365 Business Central Essentials
• Microsoft Dynamics 365 Business Central Premium

Supported Versions:

• Business Central 22 and later

AL Mandatory Fields - intelligent, rule-based data validation for Microsoft Dynamics 365 Business Central.